/*
 Navicat Premium Data Transfer

 Source Server         : docker
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : localhost:3306
 Source Schema         : bj

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : 65001

 Date: 03/01/2019 23:32:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_schedule
-- ----------------------------
DROP TABLE IF EXISTS `t_schedule`;
CREATE TABLE `t_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `clazz_id` int(11) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbixy7w6kl21bwxcdlrooxjw3j` (`clazz_id`),
  KEY `FKm0ipy9kpx0pc6hlp10hm5t5jg` (`course_id`),
  KEY `dsfasdfasdf` (`teacher_id`),
  CONSTRAINT `FKbixy7w6kl21bwxcdlrooxjw3j` FOREIGN KEY (`clazz_id`) REFERENCES `t_clazz` (`id`),
  CONSTRAINT `FKm0ipy9kpx0pc6hlp10hm5t5jg` FOREIGN KEY (`course_id`) REFERENCES `t_course` (`id`),
  CONSTRAINT `dsfasdfasdf` FOREIGN KEY (`teacher_id`) REFERENCES `t_teacher` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_schedule
-- ----------------------------
BEGIN;
INSERT INTO `t_schedule` VALUES (1, '2013级31班语文', 1, 1, 1);
INSERT INTO `t_schedule` VALUES (2, '2013级32班语文', 2, 1, 2);
INSERT INTO `t_schedule` VALUES (3, '2013级33班语文', 3, 1, 3);
INSERT INTO `t_schedule` VALUES (4, '2013级34班语文', 4, 1, 4);
INSERT INTO `t_schedule` VALUES (5, '2013级35班语文', 5, 1, 1);
INSERT INTO `t_schedule` VALUES (6, '2014级41班语文', 6, 1, 1);
INSERT INTO `t_schedule` VALUES (7, '2014级42班语文', 7, 1, 1);
INSERT INTO `t_schedule` VALUES (8, '2014级43班语文', 8, 1, 1);
INSERT INTO `t_schedule` VALUES (9, '2015级51班语文', 10, 1, 1);
INSERT INTO `t_schedule` VALUES (10, '2016级21班语文', 11, 1, 1);
INSERT INTO `t_schedule` VALUES (11, '2013级31班数学', 1, 2, 1);
INSERT INTO `t_schedule` VALUES (12, '2013级32班数学', 2, 2, 1);
INSERT INTO `t_schedule` VALUES (13, '2013级33班数学', 3, 2, 1);
INSERT INTO `t_schedule` VALUES (14, '2013级34班数学', 4, 2, 1);
INSERT INTO `t_schedule` VALUES (15, '2013级35班数学', 5, 2, 1);
INSERT INTO `t_schedule` VALUES (16, '2014级41班数学', 6, 2, 1);
INSERT INTO `t_schedule` VALUES (17, '2014级42班数学', 7, 2, NULL);
INSERT INTO `t_schedule` VALUES (18, '2014级43班数学', 8, 2, NULL);
INSERT INTO `t_schedule` VALUES (19, '2015级51班数学', 10, 2, NULL);
INSERT INTO `t_schedule` VALUES (20, '2016级21班数学', 11, 2, NULL);
INSERT INTO `t_schedule` VALUES (21, '2013级31班英语', 1, 3, 8);
INSERT INTO `t_schedule` VALUES (22, '2013级32班英语', 2, 3, NULL);
INSERT INTO `t_schedule` VALUES (23, '2013级33班英语', 3, 3, NULL);
INSERT INTO `t_schedule` VALUES (24, '2013级34班英语', 4, 3, NULL);
INSERT INTO `t_schedule` VALUES (25, '2013级35班英语', 5, 3, NULL);
INSERT INTO `t_schedule` VALUES (26, '2014级41班英语', 6, 3, NULL);
INSERT INTO `t_schedule` VALUES (27, '2014级42班英语', 7, 3, NULL);
INSERT INTO `t_schedule` VALUES (28, '2014级43班英语', 8, 3, NULL);
INSERT INTO `t_schedule` VALUES (29, '2015级51班英语', 10, 3, NULL);
INSERT INTO `t_schedule` VALUES (30, '2016级21班英语', 11, 3, NULL);
INSERT INTO `t_schedule` VALUES (32, '2013级32班物理', 2, 4, NULL);
INSERT INTO `t_schedule` VALUES (33, '2013级33班物理', 3, 4, NULL);
INSERT INTO `t_schedule` VALUES (34, '2013级34班物理', 4, 4, NULL);
INSERT INTO `t_schedule` VALUES (35, '2013级35班物理', 5, 4, 7);
INSERT INTO `t_schedule` VALUES (36, '2014级41班物理', 6, 4, NULL);
INSERT INTO `t_schedule` VALUES (37, '2014级42班物理', 7, 4, NULL);
INSERT INTO `t_schedule` VALUES (38, '2014级43班物理', 8, 4, NULL);
INSERT INTO `t_schedule` VALUES (39, '2015级51班物理', 10, 4, NULL);
INSERT INTO `t_schedule` VALUES (40, '2016级21班物理', 11, 4, NULL);
INSERT INTO `t_schedule` VALUES (41, '2013级31班化学', 1, 5, NULL);
INSERT INTO `t_schedule` VALUES (42, '2013级32班化学', 2, 5, NULL);
INSERT INTO `t_schedule` VALUES (43, '2013级33班化学', 3, 5, NULL);
INSERT INTO `t_schedule` VALUES (44, '2013级34班化学', 4, 5, NULL);
INSERT INTO `t_schedule` VALUES (45, '2013级35班化学', 5, 5, NULL);
INSERT INTO `t_schedule` VALUES (46, '2014级41班化学', 6, 5, NULL);
INSERT INTO `t_schedule` VALUES (47, '2014级42班化学', 7, 5, NULL);
INSERT INTO `t_schedule` VALUES (48, '2014级43班化学', 8, 5, NULL);
INSERT INTO `t_schedule` VALUES (49, '2015级51班化学', 10, 5, NULL);
INSERT INTO `t_schedule` VALUES (50, '2016级21班化学', 11, 5, NULL);
INSERT INTO `t_schedule` VALUES (52, '2013级32班生物', 2, 6, NULL);
INSERT INTO `t_schedule` VALUES (53, '2013级33班生物', 3, 6, NULL);
INSERT INTO `t_schedule` VALUES (54, '2013级34班生物', 4, 6, NULL);
INSERT INTO `t_schedule` VALUES (55, '2013级35班生物', 5, 6, NULL);
INSERT INTO `t_schedule` VALUES (56, '2014级41班生物', 6, 6, NULL);
INSERT INTO `t_schedule` VALUES (57, '2014级42班生物', 7, 6, NULL);
INSERT INTO `t_schedule` VALUES (58, '2014级43班生物', 8, 6, NULL);
INSERT INTO `t_schedule` VALUES (59, '2015级51班生物', 10, 6, NULL);
INSERT INTO `t_schedule` VALUES (60, '2016级21班生物', 11, 6, NULL);
INSERT INTO `t_schedule` VALUES (62, '2013级32班历史', 2, 7, NULL);
INSERT INTO `t_schedule` VALUES (63, '2013级33班历史', 3, 7, NULL);
INSERT INTO `t_schedule` VALUES (64, '2013级34班历史', 4, 7, NULL);
INSERT INTO `t_schedule` VALUES (65, '2013级35班历史', 5, 7, NULL);
INSERT INTO `t_schedule` VALUES (66, '2014级41班历史', 6, 7, 3);
INSERT INTO `t_schedule` VALUES (67, '2014级42班历史', 7, 7, NULL);
INSERT INTO `t_schedule` VALUES (68, '2014级43班历史', 8, 7, NULL);
INSERT INTO `t_schedule` VALUES (69, '2015级51班历史', 10, 7, NULL);
INSERT INTO `t_schedule` VALUES (70, '2016级21班历史', 11, 7, NULL);
INSERT INTO `t_schedule` VALUES (72, '2013级32班政治', 2, 8, NULL);
INSERT INTO `t_schedule` VALUES (73, '2013级33班政治', 3, 8, NULL);
INSERT INTO `t_schedule` VALUES (74, '2013级34班政治', 4, 8, NULL);
INSERT INTO `t_schedule` VALUES (75, '2013级35班政治', 5, 8, NULL);
INSERT INTO `t_schedule` VALUES (76, '2014级41班政治', 6, 8, NULL);
INSERT INTO `t_schedule` VALUES (77, '2014级42班政治', 7, 8, NULL);
INSERT INTO `t_schedule` VALUES (78, '2014级43班政治', 8, 8, NULL);
INSERT INTO `t_schedule` VALUES (79, '2015级51班政治', 10, 8, NULL);
INSERT INTO `t_schedule` VALUES (80, '2016级21班政治', 11, 8, NULL);
INSERT INTO `t_schedule` VALUES (82, '2013级32班计算机', 2, 9, NULL);
INSERT INTO `t_schedule` VALUES (83, '2013级33班计算机', 3, 9, NULL);
INSERT INTO `t_schedule` VALUES (84, '2013级34班计算机', 4, 9, NULL);
INSERT INTO `t_schedule` VALUES (85, '2013级35班计算机', 5, 9, NULL);
INSERT INTO `t_schedule` VALUES (86, '2014级41班计算机', 6, 9, NULL);
INSERT INTO `t_schedule` VALUES (87, '2014级42班计算机', 7, 9, NULL);
INSERT INTO `t_schedule` VALUES (88, '2014级43班计算机', 8, 9, NULL);
INSERT INTO `t_schedule` VALUES (89, '2015级51班计算机', 10, 9, NULL);
INSERT INTO `t_schedule` VALUES (90, '2016级21班计算机', 11, 9, NULL);
INSERT INTO `t_schedule` VALUES (92, '2013级32班体育', 2, 10, NULL);
INSERT INTO `t_schedule` VALUES (93, '2013级33班体育', 3, 10, NULL);
INSERT INTO `t_schedule` VALUES (94, '2013级34班体育', 4, 10, NULL);
INSERT INTO `t_schedule` VALUES (95, '2013级35班体育', 5, 10, NULL);
INSERT INTO `t_schedule` VALUES (96, '2014级41班体育', 6, 10, NULL);
INSERT INTO `t_schedule` VALUES (97, '2014级42班体育', 7, 10, NULL);
INSERT INTO `t_schedule` VALUES (98, '2014级43班体育', 8, 10, NULL);
INSERT INTO `t_schedule` VALUES (99, '2015级51班体育', 10, 10, NULL);
INSERT INTO `t_schedule` VALUES (100, '2016级21班体育', 11, 10, NULL);
INSERT INTO `t_schedule` VALUES (101, '2013级31班物理', 1, 4, 1);
COMMIT;

-- ----------------------------
-- Table structure for t_clazz
-- ----------------------------
DROP TABLE IF EXISTS `t_clazz`;
CREATE TABLE `t_clazz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_clazz
-- ----------------------------
BEGIN;
INSERT INTO `t_clazz` VALUES (1, '2013级31班');
INSERT INTO `t_clazz` VALUES (2, '2013级32班');
INSERT INTO `t_clazz` VALUES (3, '2013级33班');
INSERT INTO `t_clazz` VALUES (4, '2013级34班');
INSERT INTO `t_clazz` VALUES (5, '2013级35班');
INSERT INTO `t_clazz` VALUES (6, '2014级41班');
INSERT INTO `t_clazz` VALUES (7, '2014级42班');
INSERT INTO `t_clazz` VALUES (8, '2014级43班');
INSERT INTO `t_clazz` VALUES (10, '2015级51班');
INSERT INTO `t_clazz` VALUES (11, '2016级21班');
COMMIT;

-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_course
-- ----------------------------
BEGIN;
INSERT INTO `t_course` VALUES (1, '语文');
INSERT INTO `t_course` VALUES (2, '数学');
INSERT INTO `t_course` VALUES (3, '英语');
INSERT INTO `t_course` VALUES (4, '物理');
INSERT INTO `t_course` VALUES (5, '化学');
INSERT INTO `t_course` VALUES (6, '生物');
INSERT INTO `t_course` VALUES (7, '历史');
INSERT INTO `t_course` VALUES (8, '政治');
INSERT INTO `t_course` VALUES (9, '计算机');
INSERT INTO `t_course` VALUES (10, '体育');
INSERT INTO `t_course` VALUES (11, 'ddd');
COMMIT;

-- ----------------------------
-- Table structure for t_score
-- ----------------------------
DROP TABLE IF EXISTS `t_score`;
CREATE TABLE `t_score` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` double DEFAULT NULL,
  `schedule_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKs943atieh3xpxcjrtdl93jpp6` (`schedule_id`),
  KEY `FK9yiug4y55bkn06wffy1m32px0` (`student_id`),
  CONSTRAINT `FK9yiug4y55bkn06wffy1m32px0` FOREIGN KEY (`student_id`) REFERENCES `t_student` (`id`),
  CONSTRAINT `FKs943atieh3xpxcjrtdl93jpp6` FOREIGN KEY (`schedule_id`) REFERENCES `t_schedule` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_score
-- ----------------------------
BEGIN;
INSERT INTO `t_score` VALUES (1, 50, 2, 21);
INSERT INTO `t_score` VALUES (19, 0, 1, 21);
INSERT INTO `t_score` VALUES (20, 0, 1, 22);
INSERT INTO `t_score` VALUES (21, 0, 1, 23);
INSERT INTO `t_score` VALUES (22, 0, 1, 24);
INSERT INTO `t_score` VALUES (23, 0, 1, 25);
INSERT INTO `t_score` VALUES (24, 0, 1, 26);
INSERT INTO `t_score` VALUES (25, 0, 1, 27);
INSERT INTO `t_score` VALUES (26, 0, 1, 28);
INSERT INTO `t_score` VALUES (27, 0, 1, 29);
INSERT INTO `t_score` VALUES (28, 0, 1, 30);
INSERT INTO `t_score` VALUES (29, 0, 1, 31);
INSERT INTO `t_score` VALUES (30, 0, 1, 32);
INSERT INTO `t_score` VALUES (31, 0, 1, 33);
INSERT INTO `t_score` VALUES (32, 0, 1, 34);
INSERT INTO `t_score` VALUES (33, 0, 1, 35);
INSERT INTO `t_score` VALUES (34, 0, 1, 36);
INSERT INTO `t_score` VALUES (35, 0, 1, 37);
INSERT INTO `t_score` VALUES (36, 0, 1, 38);
INSERT INTO `t_score` VALUES (37, 0, 1, 39);
INSERT INTO `t_score` VALUES (38, 0, 1, 40);
INSERT INTO `t_score` VALUES (39, 0, 1, 41);
INSERT INTO `t_score` VALUES (40, 0, 1, 42);
INSERT INTO `t_score` VALUES (41, 0, 1, 43);
INSERT INTO `t_score` VALUES (42, 0, 1, 44);
INSERT INTO `t_score` VALUES (43, 0, 1, 45);
INSERT INTO `t_score` VALUES (44, 0, 1, 46);
INSERT INTO `t_score` VALUES (45, 0, 1, 47);
INSERT INTO `t_score` VALUES (46, 0, 1, 48);
INSERT INTO `t_score` VALUES (47, 0, 1, 49);
INSERT INTO `t_score` VALUES (48, 0, 1, 50);
INSERT INTO `t_score` VALUES (49, 0, 1, 51);
INSERT INTO `t_score` VALUES (50, 0, 1, 52);
INSERT INTO `t_score` VALUES (51, 0, 1, 53);
INSERT INTO `t_score` VALUES (52, 0, 1, 54);
INSERT INTO `t_score` VALUES (53, 0, 1, 55);
INSERT INTO `t_score` VALUES (54, 0, 1, 56);
INSERT INTO `t_score` VALUES (55, 0, 1, 57);
INSERT INTO `t_score` VALUES (56, 0, 1, 58);
INSERT INTO `t_score` VALUES (57, 0, 11, 21);
INSERT INTO `t_score` VALUES (58, 0, 11, 22);
INSERT INTO `t_score` VALUES (59, 0, 11, 23);
INSERT INTO `t_score` VALUES (60, 0, 11, 24);
INSERT INTO `t_score` VALUES (61, 0, 11, 25);
INSERT INTO `t_score` VALUES (62, 0, 11, 26);
INSERT INTO `t_score` VALUES (63, 0, 11, 27);
INSERT INTO `t_score` VALUES (64, 0, 11, 28);
INSERT INTO `t_score` VALUES (65, 0, 11, 29);
INSERT INTO `t_score` VALUES (66, 0, 11, 30);
INSERT INTO `t_score` VALUES (67, 0, 11, 31);
INSERT INTO `t_score` VALUES (68, 0, 11, 32);
INSERT INTO `t_score` VALUES (69, 0, 11, 33);
INSERT INTO `t_score` VALUES (70, 0, 11, 34);
INSERT INTO `t_score` VALUES (71, 0, 11, 35);
INSERT INTO `t_score` VALUES (72, 0, 11, 36);
INSERT INTO `t_score` VALUES (73, 0, 11, 37);
INSERT INTO `t_score` VALUES (74, 0, 11, 38);
INSERT INTO `t_score` VALUES (75, 0, 11, 39);
INSERT INTO `t_score` VALUES (76, 0, 11, 40);
INSERT INTO `t_score` VALUES (77, 0, 11, 41);
INSERT INTO `t_score` VALUES (78, 0, 11, 42);
INSERT INTO `t_score` VALUES (79, 0, 11, 43);
INSERT INTO `t_score` VALUES (80, 0, 11, 44);
INSERT INTO `t_score` VALUES (81, 0, 11, 45);
INSERT INTO `t_score` VALUES (82, 0, 11, 46);
INSERT INTO `t_score` VALUES (83, 0, 11, 47);
INSERT INTO `t_score` VALUES (84, 0, 11, 48);
INSERT INTO `t_score` VALUES (85, 0, 11, 49);
INSERT INTO `t_score` VALUES (86, 0, 11, 50);
INSERT INTO `t_score` VALUES (87, 0, 11, 51);
INSERT INTO `t_score` VALUES (88, 0, 11, 52);
INSERT INTO `t_score` VALUES (89, 0, 11, 53);
INSERT INTO `t_score` VALUES (90, 0, 11, 54);
INSERT INTO `t_score` VALUES (91, 0, 11, 55);
INSERT INTO `t_score` VALUES (92, 0, 11, 56);
INSERT INTO `t_score` VALUES (93, 0, 11, 57);
INSERT INTO `t_score` VALUES (94, 0, 11, 58);
INSERT INTO `t_score` VALUES (95, 0, 21, 21);
INSERT INTO `t_score` VALUES (96, 0, 21, 22);
INSERT INTO `t_score` VALUES (97, 0, 21, 23);
INSERT INTO `t_score` VALUES (98, 0, 21, 24);
INSERT INTO `t_score` VALUES (99, 0, 21, 25);
INSERT INTO `t_score` VALUES (100, 0, 21, 26);
INSERT INTO `t_score` VALUES (101, 0, 21, 27);
INSERT INTO `t_score` VALUES (102, 0, 21, 28);
INSERT INTO `t_score` VALUES (103, 0, 21, 29);
INSERT INTO `t_score` VALUES (104, 0, 21, 30);
INSERT INTO `t_score` VALUES (105, 0, 21, 31);
INSERT INTO `t_score` VALUES (106, 0, 21, 32);
INSERT INTO `t_score` VALUES (107, 0, 21, 33);
INSERT INTO `t_score` VALUES (108, 0, 21, 34);
INSERT INTO `t_score` VALUES (109, 0, 21, 35);
INSERT INTO `t_score` VALUES (110, 0, 21, 36);
INSERT INTO `t_score` VALUES (111, 0, 21, 37);
INSERT INTO `t_score` VALUES (112, 0, 21, 38);
INSERT INTO `t_score` VALUES (113, 0, 21, 39);
INSERT INTO `t_score` VALUES (114, 0, 21, 40);
INSERT INTO `t_score` VALUES (115, 0, 21, 41);
INSERT INTO `t_score` VALUES (116, 0, 21, 42);
INSERT INTO `t_score` VALUES (117, 0, 21, 43);
INSERT INTO `t_score` VALUES (118, 0, 21, 44);
INSERT INTO `t_score` VALUES (119, 0, 21, 45);
INSERT INTO `t_score` VALUES (120, 0, 21, 46);
INSERT INTO `t_score` VALUES (121, 0, 21, 47);
INSERT INTO `t_score` VALUES (122, 0, 21, 48);
INSERT INTO `t_score` VALUES (123, 0, 21, 49);
INSERT INTO `t_score` VALUES (124, 0, 21, 50);
INSERT INTO `t_score` VALUES (125, 0, 21, 51);
INSERT INTO `t_score` VALUES (126, 0, 21, 52);
INSERT INTO `t_score` VALUES (127, 0, 21, 53);
INSERT INTO `t_score` VALUES (128, 0, 21, 54);
INSERT INTO `t_score` VALUES (129, 0, 21, 55);
INSERT INTO `t_score` VALUES (130, 0, 21, 56);
INSERT INTO `t_score` VALUES (131, 0, 21, 57);
INSERT INTO `t_score` VALUES (132, 0, 21, 58);
COMMIT;

-- ----------------------------
-- Table structure for t_student
-- ----------------------------
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL,
  `clazz_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK86xs8ow9uasv8eew6aup5g8pg` (`clazz_id`),
  CONSTRAINT `FK86xs8ow9uasv8eew6aup5g8pg` FOREIGN KEY (`clazz_id`) REFERENCES `t_clazz` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_student
-- ----------------------------
BEGIN;
INSERT INTO `t_student` VALUES (18, '201301002', '妮可罗宾', '111111', 2, 2);
INSERT INTO `t_student` VALUES (19, '201301003', '罗罗诺亚卓洛', '111111', 2, 8);
INSERT INTO `t_student` VALUES (21, '201301005', '娜美e', '111111', 2, 1);
INSERT INTO `t_student` VALUES (22, '201301006', '山治', '111111', 2, 1);
INSERT INTO `t_student` VALUES (23, '201301007', '布鲁克', '111111', 2, 1);
INSERT INTO `t_student` VALUES (24, '201301008', '乌索普', '111111', 2, 1);
INSERT INTO `t_student` VALUES (25, '201301009', '弗兰奇', '111111', 2, 1);
INSERT INTO `t_student` VALUES (26, '201301010', '娜菲鲁塔利薇薇', '111111', 2, 1);
INSERT INTO `t_student` VALUES (27, '201301011', '小鱿', '111111', 2, 1);
INSERT INTO `t_student` VALUES (28, '201301012', '梅里号', '111111', 2, 1);
INSERT INTO `t_student` VALUES (29, '201301013', '阳光号', '111111', 2, 1);
INSERT INTO `t_student` VALUES (30, '201302001', '马歇尔蒂奇', '111111', 2, 1);
INSERT INTO `t_student` VALUES (31, '201302002', '范奥卡', '111111', 2, 1);
INSERT INTO `t_student` VALUES (32, '201302003', '基萨斯巴加斯', '111111', 2, 1);
INSERT INTO `t_student` VALUES (33, '201302004', '毒Q', '111111', 2, 1);
INSERT INTO `t_student` VALUES (34, '201302005', '雨之希留', '111111', 2, 1);
INSERT INTO `t_student` VALUES (35, '201302006', '卡特琳娜', '111111', 2, 1);
INSERT INTO `t_student` VALUES (36, '201302007', '圣胡安恶狼', '111111', 2, 1);
INSERT INTO `t_student` VALUES (37, '201302008', '巴克斯乔特', '111111', 2, 1);
INSERT INTO `t_student` VALUES (38, '201302009', '阿巴罗', '111111', 2, 1);
INSERT INTO `t_student` VALUES (39, '201303001', '汉库克', '111111', 2, 1);
INSERT INTO `t_student` VALUES (40, '201303002', '桑达索尼娅', '111111', 2, 1);
INSERT INTO `t_student` VALUES (41, '201303003', '玛丽哥鲁德', '111111', 2, 1);
INSERT INTO `t_student` VALUES (42, '201303004', '玛格丽特', '111111', 2, 1);
INSERT INTO `t_student` VALUES (43, '201303005', '艾弗兰德拉', '111111', 2, 1);
INSERT INTO `t_student` VALUES (44, '201303006', '贝拉董娜', '111111', 2, 1);
INSERT INTO `t_student` VALUES (45, '201304001', '白胡子', '111111', 2, 1);
INSERT INTO `t_student` VALUES (46, '201304002', '马尔高', '111111', 2, 1);
INSERT INTO `t_student` VALUES (47, '201304003', '艾斯', '111111', 2, 1);
INSERT INTO `t_student` VALUES (48, '201304004', '乔兹', '111111', 2, 1);
INSERT INTO `t_student` VALUES (49, '201304005', '萨奇', '111111', 2, 1);
INSERT INTO `t_student` VALUES (50, '201304006', '比斯塔', '111111', 2, 1);
INSERT INTO `t_student` VALUES (51, '201304007', '布拉曼克', '111111', 2, 1);
INSERT INTO `t_student` VALUES (52, '201304008', '拉克约', '111111', 2, 1);
INSERT INTO `t_student` VALUES (53, '201304009', '那谬尔', '111111', 2, 1);
INSERT INTO `t_student` VALUES (54, '201304010', '布伦海姆', '111111', 2, 1);
INSERT INTO `t_student` VALUES (55, '201304011', '库利艾尔', '111111', 2, 1);
INSERT INTO `t_student` VALUES (56, '201304012', '金古多', '111111', 2, 1);
INSERT INTO `t_student` VALUES (57, '201304013', '佛萨', '111111', 2, 1);
INSERT INTO `t_student` VALUES (58, '201304014', '斯比多基尔', '111111', 2, 1);
INSERT INTO `t_student` VALUES (59, '201401001', '日向雏田', '111111', 2, 2);
INSERT INTO `t_student` VALUES (60, '201401002', '李洛克', '111111', 2, 2);
INSERT INTO `t_student` VALUES (61, '201401003', '日向花火', '111111', 2, 2);
INSERT INTO `t_student` VALUES (62, '201401004', '奈良鹿丸', '111111', 2, 2);
INSERT INTO `t_student` VALUES (63, '201401005', '日向宁次', '111111', 2, 2);
INSERT INTO `t_student` VALUES (64, '201401006', '佐井', '111111', 2, 2);
INSERT INTO `t_student` VALUES (65, '201401007', '山中井野', '111111', 2, 2);
INSERT INTO `t_student` VALUES (66, '201401008', '秋道丁次', '111111', 2, 2);
INSERT INTO `t_student` VALUES (67, '201401009', '犬冢牙', '111111', 2, 2);
INSERT INTO `t_student` VALUES (68, '201401010', '野原琳', '111111', 2, 2);
INSERT INTO `t_student` VALUES (69, '201401011', '天天', '111111', 2, 2);
INSERT INTO `t_student` VALUES (70, '201401012', '木叶丸', '111111', 2, 2);
INSERT INTO `t_student` VALUES (71, '201401013', '赤丸', '111111', 2, 2);
INSERT INTO `t_student` VALUES (72, '201401014', '漩涡鸣人', '111111', 2, 2);
INSERT INTO `t_student` VALUES (73, '201401015', '佐助', '111111', 2, 2);
INSERT INTO `t_student` VALUES (74, '201401016', '春野樱', '111111', 2, 2);
INSERT INTO `t_student` VALUES (75, '201401017', '油女志乃', '111111', 2, 2);
INSERT INTO `t_student` VALUES (76, '201402001', '宇智波带土', '111111', 2, 2);
INSERT INTO `t_student` VALUES (77, '201402002', '长门', '111111', 2, 2);
INSERT INTO `t_student` VALUES (78, '201402003', '绝', '111111', 2, 2);
INSERT INTO `t_student` VALUES (79, '201402004', '角都', '111111', 2, 2);
INSERT INTO `t_student` VALUES (80, '201402005', '迪达拉', '111111', 2, 2);
INSERT INTO `t_student` VALUES (81, '201402006', '小南', '111111', 2, 2);
INSERT INTO `t_student` VALUES (82, '201402007', '大蛇丸', '111111', 2, 2);
INSERT INTO `t_student` VALUES (83, '201402008', '飞段', '111111', 2, 2);
INSERT INTO `t_student` VALUES (84, '201402009', '蝎', '111111', 2, 2);
INSERT INTO `t_student` VALUES (85, '201402010', '弥彦', '111111', 2, 2);
INSERT INTO `t_student` VALUES (86, '201402011', '千柿鬼鲛', '111111', 2, 2);
INSERT INTO `t_student` VALUES (88, '201554001', 'h呵呵呵', '111111', 2, 3);
INSERT INTO `t_student` VALUES (90, '201442001', 'rrrrrr', '111111', 2, 7);
INSERT INTO `t_student` VALUES (92, '201402012', 'xxxxx', '111111', 2, 2);
COMMIT;

-- ----------------------------
-- Table structure for t_teacher
-- ----------------------------
DROP TABLE IF EXISTS `t_teacher`;
CREATE TABLE `t_teacher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_teacher
-- ----------------------------
BEGIN;
INSERT INTO `t_teacher` VALUES (1, '2001', '卡卡西', '111111', 3);
INSERT INTO `t_teacher` VALUES (2, '2002', '卡普', '111111', 3);
INSERT INTO `t_teacher` VALUES (3, '2003', '战国', '111111', 3);
INSERT INTO `t_teacher` VALUES (4, '2004', '青雉', '111111', 3);
INSERT INTO `t_teacher` VALUES (5, '2005', '爱德华纽盖特', '111111', 3);
INSERT INTO `t_teacher` VALUES (6, '2006', '香克斯', '111111', 3);
INSERT INTO `t_teacher` VALUES (7, '2007', '波风水门', '111111', 3);
INSERT INTO `t_teacher` VALUES (8, '2008', '纲手', '111111', 3);
INSERT INTO `t_teacher` VALUES (9, '2009', '大筒木辉夜', '111111', 3);
INSERT INTO `t_teacher` VALUES (10, '2010', '漩涡玖辛奈', '111111', 3);
INSERT INTO `t_teacher` VALUES (11, '2011', '夕日红', '111111', 3);
INSERT INTO `t_teacher` VALUES (12, '2012', '鹰眼米霍克', '111111', 3);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
